You can specify advanced options on the index as well as define multiple columns in the same index with ascending or descending order clause Ddl 。您可以在索引上指定高級選項(xiàng),以及用ascending或descending order子句在同一索引中定義多個(gè)列。
If the data file is sorted in a different order , that is other than the order of a clustered index key , or if there is no clustered index on the table , the order clause is ignored 如果根據(jù)表中的聚集索引對要加載的數(shù)據(jù)排序,則可提高大容量復(fù)制的性能。如果數(shù)據(jù)文件按不同次序排序,或者該表沒有聚集索引,則將忽略order提示。